Spread WPF Documentation
Evaluate(Object[]) Method


The args contains 2 - 3 items: range, criteria, [average_range].

Range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.

Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.

[Average_range] is the actual set of cells to average. If omitted, range is used.

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object
'Usage
 
Dim instance As CalcAverageIfFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)
public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 2 - 3 items: range, criteria, [average_range].

Range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.

Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.

[Average_range] is the actual set of cells to average. If omitted, range is used.

Return Value

A System.Object value that indicates the evaluate result.
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

CalcAverageIfFunction Class
CalcAverageIfFunction Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.